﻿<?xml version="1.0" encoding="UTF-8"?>
<form title="BOM" icon="cube.gif" description="" xmlns="http://www.evolutility.com">
  <data dbtable="MRP_MaterialMain" splogin="asp.net membership" dbwhere="MType=5" dbcolumnpk="ID" sppaging="EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @SQLpk, @pageid, @pagesize" />
  <panel userid="1" label="基本信息" width="80">
    <field id="85" type="text" typeid="5" label="物料编码" dbcolumn="MCode" dbcolumnread="MCode" maxlength="32" readonly="1" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="40" />
   <field id="38" type="lov" typeid="5" label="物料种类" dbcolumn="MType" dbcolumnread="MaterialType"
 dbtablelov="View_MaterialType_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="2" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="10" />
     <field id="1292" type="text" typeid="5" label="图纸编码" dbcolumn="DiagramCode" dbcolumnread="DiagramCode" maxlength="50" readonly="1" required="" optional="" fpos="80" search="0" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="238" type="lov" typeid="5" label="型号大小" dbcolumn="SizeType" dborderlov ="ID" dbcolumnread="MaterialSizeType"
 dbtablelov="View_ProductSize_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="1" required="0" optional="" fpos="30" search="1" searchadv="1" searchlist="1" height="1" width="10" />
    <field id="103" type="textmultiline" typeid="6" label="规格" dbcolumn="Specification" dbcolumnread="Specification" maxlength="256" readonly="1" required="1" optional="" fpos="190" search="0" searchadv="1" searchlist="1" height="2" width="60" />
    <field id="101" type="decimal" typeid="10" label="单重(kg)" dbcolumn="Weight" defaultvalue="0" dbcolumnread="Weight" maxlength="8" readonly="1" required="" optional="" fpos="170" search="0" searchadv="1" searchlist="1" height="1" width="20" />

  </panel>
  <panel-details panelid="1" dbtabledetails="MRP_MaterialInProduct" dbcolumndetails="ProductID" label="物料组成">
    <field panelid="1" id="187" type="lov" typeid="5" label="物料名称" dbwherelov="View_MaterialNameAndCode.MType>5" dbcolumn="MaterialID" dbcolumnread="Name1"
 dbtablelov="View_MaterialNameAndCode" dbcolumnreadlov="NameAndCode" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="60" />
    <field panelid="1" id="188" type="decimal" typeid="10" label="物料数量" dbcolumn="MaterialCount" dbcolumnread="MaterialCount" maxlength="8" readonly="0" required="1" optional="" fpos="40" search="0" searchadv="1" searchlist="1" height="1" width="40" />
  </panel-details>
  <queries label="预定义的查询">
    <query label="没有BOM表的产品" dbwhere="not exists(Select ID from MRP_MaterialInProduct where ProductID=T.ID)" url="noBOM" />
    <query label="有BOM表的产品" dbwhere="exists(Select ID from MRP_MaterialInProduct where ProductID=T.ID)" url="hasBOM" />
  </queries>
</form>
